Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkstationID (FK)(PK) | The unique identifier for the WORKSTATION, typically the serial number. | ID_WS | Identity | integer | Workstation(AS_WS) |
WorkstationDate (PK) | The actual date recorded by the WORKSTATION. | DC_WS | DateCalendar | date | |
TimePeriodHour (PK) | The time periods expressed in hours to measure line and transaction activity. | IN_PRD_TM_HR | QuantityShortCountHours | numeric(2,0) | |
TimePeriodMinuteIntervalCount (PK) | The number of intervals in minutes for measuring line and transaction activity. | QU_INTV_PR_MN_PRD | QuantityShortCountMinutes | decimal(4,0) | |
TimePeriodIntervalPerHourCount (PK) | The number of time intervals per hour for measuring line and transaction activity. | QU_INTV_PR_HR_PRD | QuantityShortCount | decimal(5,0) | |
NetSalesTotalAmount | The net sales amount recorded by the WORKSTATION in the defined time period intervals. | CP_SLS_NT | Money | decimal(16,5) | |
TotalSaleLineItemCount | The total number of line items sold by the WORKSTATION in the defined time period intervals. | QU_SLS_LN_ITM | QuantityTransactionCount | decimal(7,0) | |
TotalTransactionCount | A WORKSATION accumulator for holding the number of TRANSACTIONs across the defined time intervals. | QU_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
SignOnTimeMinutesCount | The number of minutes since the OPERATOR signed on the WORKSTATION. | MI_SGN_ON | QuantityShortCountMinutes | decimal(4,0) | |